﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace ConfigForm.BLL
{
    class TPriceUnit
    {
        UTLDB.UTLDB connect = new UTLDB.UTLDB();
        public DataTable GetPriceUnit()
        {

            DataTable data = connect.GetDataByStoredProcedure("usp_SelecttblPriceUnitsAll");
            return data;
        }
        public DataTable GetType()
        {

            DataTable data = connect.GetDataByStoredProcedure("sp_SelecttblProductTypesAll");
            return data;
        }
        public DataTable GetUnit()
        {

            DataTable data = connect.GetDataByStoredProcedure("sp_Select_tblUnit");
            return data;
        }
        public DataTable GetMaterial()
        {
            DataTable data = connect.GetDataByStoredProcedure("usp_SelecttblMaterial");
            return data;
        }
        public DataTable GetSeedType()
        {
            DataTable data = connect.GetDataByStoredProcedure("usp_SelecttblSeedType");
            return data;
        }
        public DataTable GetQuality()
        {
            DataTable data = connect.GetDataByStoredProcedure("usp_SelecttblQuality");
            return data;
        }
        public DataTable GetSeed()
        {
            DataTable data = connect.GetDataByStoredProcedure("sp_SelecttblSeedsAll");
            return data;
        }
    }
}
